{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inputs","Extract","Lists"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":2,"defined_names":120,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inputs","index":0,"n_rows":189,"n_cols":41,"rows_kept":189,"cut":false,"hidden":false,"merged":[[6,6,6,10],[170,11,170,13],[168,1,168,10],[141,1,141,5],[146,6,146,12],[147,6,147,12],[148,6,148,12],[149,6,149,12],[150,6,150,12],[6,1,6,5],[12,2,12,3],[18,2,23,3],[7,5,7,7],[36,5,36,7],[7,3,7,4],[36,3,36,4],[10,2,10,3],[16,2,16,3],[14,2,14,3],[188,1,188,2],[188,3,188,4],[170,1,170,6],[178,1,178,2],[178,3,178,4],[179,1,179,2],[179,3,179,4],[174,1,176,4],[181,1,183,4],[185,1,185,2],[185,3,185,4],[186,1,186,2],[186,3,186,4],[163,2,163,3],[156,2,156,3],[164,2,164,7],[144,6,144,12],[145,6,145,12],[159,2,159,7],[157,2,157,3],[158,2,158,3],[161,2,161,3],[162,2,162,3],[151,6,151,12],[152,6,152,12],[172,1,172,6]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Please only enter data in the yellow cells"]
[]
[null,"Application for a student accommodation construction & long-term loan facility"]
[]
[null,"General information"]
[]
[null,"Name of University"]
[]
[null,"Name of borrower (if different)"]
[]
[null,"Name of guarantor (if applicable)"]
[]
[null,"Name of Scheme:"]
[]
[null,"Scheme Address:"]
[]
[]
[]
[]
[]
[]
[null,"Loan application summary"]
[]
[null,"Total scheme construction cost"]
[null,"Equity contribution"]
[null,"Other capital subsidy"]
[null,"Net construction cost to be funded",{"$f":"C28-C29-C30","v":0}]
[null,"Loan applied for"]
[null,"Interest paid/rolled up during construction","Paid","<  Please select from drop-down menu"]
[null,"Completion LT loan period"]
[null,"LT loan interest basis","Fixed","<  Please select from drop-down menu"]
[null,"Fixed interest period"]
[]
[null,"Scheme data - post completion"]
[]
[]
[]
[null,null,"Weeks","Occupancy rate %"]
[null,"Number of rent weeks p.a. - core period"]
[null,"Number of rent weeks p.a. - summer recess"]
[null,"Total rent weeks p.a.",{"$f":"SUM(C43:C44)","v":0}]
[]
[null,"Rental income data"]
[]
[null,null,null,"Core period","Recess period"]
[null,"Unit type","No of units","Rent per unit pw","Rent per unit pw"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Other income data"]
[]
[null,"Unit type","No of units","Income per unit pw"]
[]
[]
[]
[]
[]
[]
[null,"Management & maintenance costs"]
[]
[null,"Type of Expenditure"]
[null,null,"% of Rent if applicable","Per unit per year"]
[]
[]
[]
[]
[]
[]
[]
[null,"Life Cycle Cost (Sinking Fund Expenditure)",null,"Year","Per unit"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[]
[null,"Scheme capital costs & construction cash flow"]
[]
[null,"PROJECT TIMING"]
[null,"Target Start on Site Date"]
[null,"Target Completion Date"]
[]
[null,"Cost element","Amount",null,null,"Expenditure profile - net of retention"]
[]
[null,"Section 1",null,null,"Month:",1,{"$f":"F95+1","v":2},{"$f":"G95+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sub-total Section 1",{"$f":"SUM(C96:C105)","v":0},{"$f":"IF(E107=C107,\"\",\"Check figures\")","v":""},{"$f":"SUM(F107:AO107)","v":0},{"$f":"SUM(F96:F105)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Section 2"]
[null,null,null,{"$f":"IF(E110=C110,\"\",\"Check figures\")","v":""},{"$f":"SUM(F110:AO110)","v":0}]
[]
[null,"Section 3"]
[null,null,null,{"$f":"IF(E113=C113,\"\",\"Check figures\")","v":""},{"$f":"SUM(F113:AO113)","v":0}]
[]
[null,"Total Sections 1-3",{"$f":"C107+C110+C113","v":0},{"$f":"IF(E115=C115,\"\",\"Check figures\")","v":""},{"$f":"SUM(F115:AO115)","v":0},{"$f":"F107+F110+F113","v":0},{"$f":"G107+G110+G113","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Section 4"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sub-total Section 4",{"$f":"SUM(C118:C127)","v":0},{"$f":"IF(E129=C129,\"\",\"Check figures\")","v":""},{"$f":"SUM(F129:AO129)","v":0},{"$f":"SUM(F118:F127)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total construction costs net of retention",{"$f":"C129+C115","v":0},{"$f":"IF(E131=C131,\"\",\"Check figures\")","v":""},{"$f":"SUM(F131:AO131)","v":0},{"$f":"F129+F115","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Retention deducted",null,{"$f":"IF(E133=C133,\"\",\"Check figures\")","v":""},{"$f":"SUM(F133:AO133)","v":0}]
[]
[null,"Total gross construction costs",{"$f":"C131+C133","v":0},{"$f":"IF(E135=C135,\"\",\"Check figures\")","v":""},{"$f":"SUM(F135:AO135)","v":0},{"$f":"F131+F133","v":0},{"$f":"G131+G133","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"SECTION 4  - ADDITIONAL INFORMATION"]
[null,"THIS SECTION MUST BE COMPLETED - FAILURE TO DO SO MAY DELAY YOUR APPLICATION"]
[]
[null,"Please confirm in the boxes providde below that you have included the following information:"]
[]
[null,null,"Borrower","Guarantor","University",null,"Comments"]
[null,"Tax clearance certificate","Yes","Yes","Yes","◄Select from dropdown menu"]
[null,"Three years' audited financial statements","Yes","Yes","Yes","◄Select from dropdown menu"]
[null,"Audit management letter for most recent financial year","No","No","No","◄Select from dropdown menu"]
[null,"Latest management accounts","Yes","Yes","Yes","◄Select from dropdown menu"]
[null,"Details of corporate ownership structure","Yes","Yes","Yes","◄Select from dropdown menu"]
[null,"Details of other current borrowings","Yes","Yes","Yes","◄Select from dropdown menu"]
[null,"Description of scheme","Yes","Yes","Yes","◄Select from dropdown menu"]
[null,"Details of planning status","Yes","Yes","Yes","◄Select from dropdown menu"]
[null,"Contractor detials","Yes","Yes","Yes","◄Select from dropdown menu"]
[]
[null,"SECTION 5 - CONTACT INFORMATION"]
[]
[null,"Primary contact person :"]
[null,"Primary contact job title :"]
[null,"Primary contact telephone number :"]
[null,"Primary contact email address :"]
[]
[null,"Secondary contact person :"]
[null,"Secondary contact job title :"]
[null,"Secondary contact telephone number :"]
[null,"Secondary contact email address :"]
[]
[null,"SECTION 6 - DECLARATION",null,null,null,"Return to guidance section"]
[]
[null,"Completion of this application with deliberately or negligently inaccurate or misleading data or completion by unauthorised signatories will invalidate this application and any rights of the applicant, any document or arrangement entered into as a result of this application."]
[]
[null,"In submitting this loan application we confirm that the information contained within this application is materially  correct and accurate, and we also confirm that we are not aware of anything that may preclude us from entering into a loan arrangement with the Housing Finance Agency plc.",null,null,null,null,null,"No","◄Select from dropdown menu",null,null,{"$f":"IF(H171=\"No\",\"Complete declaration\",\"\")","v":"Complete declaration"}]
[]
[null,"NOTICE: Under the Credit Reporting Act 2013 lenders are required to provide personal and credit information for credit applications and credit agreements of €500 and above to the Central Credit Register. This information will be held on the Central Credit Register and may be used by other lenders when making decisions on your credit applications and credit agreements"]
[]
[]
[]
[]
[null,"Signature 1"]
[null,"Name :"]
[null,"Job title :"]
[]
[]
[]
[]
[null,"Signature 2, if necessary"]
[null,"Name :"]
[null,"Job title :"]
[]
[null,"Application date :"]

{"sheet":"Extract","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Lists","index":2,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"SinkingFund"]
[null,"Cash"]
[null,"Reserve movement"]
[]
[null,"TimePeriod"]
[null,"Annual"]
[null,"Five yearly"]
[]
[null,"YearsAdjustments"]
[null,3]
[null,4]
[null,5]
[]
[null,"Type of scheme"]
[null,"Standard acquisition",null,null,null,null,null,"Errors"]
[null,"Design & Build",null,null,null,null,null,{"$f":"IF(Inputs!O174=\"OK\",0,1)","v":1},null,null,{"$f":"IF(Inputs!C157=\"\",1,0)","v":1},null,null,{"$f":"AND(Inputs!C145=\"No\",Inputs!E145=\"\")","v":false},{"$f":"IF(N18=TRUE,1,0)","v":0}]
[null,"Mortgage to Rent",null,null,null,null,null,{"$f":"IF(Inputs!O175=\"OK\",0,1)","v":1},null,null,{"$f":"IF(Inputs!C158=\"\",1,0)","v":1},null,null,{"$f":"IF(Inputs!C146=\"No\",1,0)","v":0},{"$f":"N19","v":0}]
[null,"Refinancing",null,null,null,null,null,{"$f":"IF(Inputs!O176=\"OK\",0,1)","v":1},null,null,{"$f":"IF(Inputs!C159=\"\",1,0)","v":1},null,null,{"$f":"IF(Inputs!C147=\"No\",1,0)","v":1},{"$f":"N20","v":1}]
[null,null,null,null,null,null,null,{"$f":"IF(Inputs!O177=\"OK\",0,1)","v":1},null,null,{"$f":"IF(Inputs!C160=\"\",1,0)","v":1},{"$f":"SUM(K18:K21)","v":4},null,{"$f":"AND(Inputs!C153=\"No\",Inputs!E153=\"\")","v":false},{"$f":"IF(N21=TRUE,1,0)","v":0}]
[null,"Interest basis",null,null,null,null,null,{"$f":"IF(Inputs!O178=\"OK\",0,1)","v":1},null,null,null,null,null,null,{"$f":"SUM(O18:O21)","v":1}]
[null,"Std HFA variable rate",null,null,null,null,null,{"$f":"IF(Inputs!O179=\"OK\",0,1)","v":1},null,null,{"$f":"IF(Inputs!C162=\"\",1,0)","v":1}]
[null,"Current HFA fixed rate",null,null,null,null,null,{"$f":"IF(Inputs!O180=\"OK\",0,1)","v":1},null,null,{"$f":"IF(Inputs!C163=\"\",1,0)","v":1}]
[null,"EIB fixed rate - 25 yrs",null,null,null,null,null,{"$f":"IF(Inputs!O181=\"OK\",0,1)","v":1},null,null,{"$f":"IF(Inputs!C164=\"\",1,0)","v":1}]
[null,null,null,null,null,null,null,{"$f":"IF(Inputs!O182=\"OK\",0,1)","v":1},null,null,{"$f":"IF(Inputs!C165=\"\",1,0)","v":1},{"$f":"SUM(K23:K26)","v":4}]
[null,"Property type",null,null,null,null,null,{"$f":"IF(Inputs!O183=\"Yes\",0,1)","v":1}]
[null,"Detached house",null,null,null,null,null,{"$f":"IF(Inputs!O184=\"Yes\",0,1)","v":1}]
[null,"Semi-detached house",null,null,null,null,null,{"$f":"IF(Inputs!O185=\"Yes\",0,1)","v":1}]
[null,"Terraced house",null,null,null,null,null,{"$f":"IF(Inputs!O186=\"Yes\",0,1)","v":1}]
[null,"Apartment",null,null,null,null,null,{"$f":"SUM(H18:H30)","v":13}]
[null,"Duplex"]
[]
[null,"DOE status"]
[null,"Conditional"]
[null,"Awaited"]
[null,"Agmnt signed"]
[]
[null,"Yes/No"]
[null,"Yes"]
[null,"No"]
[]
[null,"Paid/rolled up"]
[null,"Paid"]
[null,"Rolled up"]
[]
[null,"Interest basis"]
[null,"Fixed"]
[null,"Variable"]
[]
[null,"Yes/No 2"]
[null,"Yes"]
[null,"No"]
[null,"Not applicable"]